import numpy as np
import pandas as pd
from pandas_profiling import ProfileReport

admission = pd.read_csv("ADMISSIONS.csv.gz 19-49-59-485.gz")

icu = pd.read_csv("ICUSTAYS.csv.gz")

prescription = pd.read_csv("PRESCRIPTIONS.csv.gz")

/Users/fengyi111/opt/miniconda3/lib/python3.9/site-packages/IPython/core/interactiveshell.py:3441: DtypeWarning: Columns (11) have mixed types.Specify dtype option on import or set low_memory=False.
  exec(code_obj, self.user_global_ns, self.user_ns)

procedure = pd.read_csv("PROCEDUREEVENTS_MV.csv.gz")

Admission

profile_admission = ProfileReport(admission, title="Admission EDA")

profile_admission

Summarize dataset: 100%|█████████████| 43/43 [00:07<00:00,  5.46it/s, Completed]
Generate report structure: 100%|██████████████████| 1/1 [00:02<00:00,  2.51s/it]
Render HTML: 100%|████████████████████████████████| 1/1 [00:00<00:00,  1.23it/s]

ICU DEA

profile_icu = ProfileReport(icu, title="ICU EDA")

profile_icu

Summarize dataset: 100%|█████████████| 76/76 [00:07<00:00, 10.76it/s, Completed]
Generate report structure: 100%|██████████████████| 1/1 [00:02<00:00,  2.23s/it]
Render HTML: 100%|████████████████████████████████| 1/1 [00:01<00:00,  1.09s/it]

Prescription DEA

profile_prescription = ProfileReport(prescription, title="ICU EDA")

profile_prescription

Summarize dataset: 100%|█████████████| 59/59 [02:37<00:00,  2.66s/it, Completed]
Generate report structure: 100%|██████████████████| 1/1 [00:02<00:00,  2.57s/it]
Render HTML: 100%|████████████████████████████████| 1/1 [00:01<00:00,  1.26s/it]

Procedure DEA

profile_procedure = ProfileReport(procedure, title="ICU EDA")

profile_procedure

Summarize dataset: 100%|███████████| 121/121 [00:33<00:00,  3.64it/s, Completed]
Generate report structure: 100%|██████████████████| 1/1 [00:03<00:00,  3.86s/it]
Render HTML: 100%|████████████████████████████████| 1/1 [00:01<00:00,  1.96s/it]